Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 45408 |
| Missing cells | 90816 |
| Missing cells (%) | 12.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.5 MiB |
| Average record size in memory | 128.0 B |
Variable types
| NUM | 12 |
|---|---|
| UNSUPPORTED | 2 |
| CAT | 1 |
| DATE | 1 |
client_id has constant value "45408" | Constant |
total_tx_data has 45408 (100.0%) missing values | Missing |
total_rx_data has 45408 (100.0%) missing values | Missing |
stats_timestamp has unique values | Unique |
total_tx_data is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_rx_data is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_attached_user has 688 (1.5%) zeros | Zeros |
total_rejected_user has 7523 (16.6%) zeros | Zeros |
peak_download_speed has 688 (1.5%) zeros | Zeros |
enodeb_shutdown_count has 4380 (9.6%) zeros | Zeros |
handover_failure_count has 4428 (9.8%) zeros | Zeros |
bearer_active_user_count has 4425 (9.7%) zeros | Zeros |
bearer_rejected_user_count has 4547 (10.0%) zeros | Zeros |
total_users has 4499 (9.9%) zeros | Zeros |
total_dropped_packets has 688 (1.5%) zeros | Zeros |
enodeb_connected_count has 4468 (9.8%) zeros | Zeros |
enodeb_connection_status has 4421 (9.7%) zeros | Zeros |
Reproduction
| Analysis started | 2022-09-21 17:21:39.355983 |
|---|---|
| Analysis finished | 2022-09-21 17:21:53.721689 |
| Duration | 14.37 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 354.8 KiB |
| BETBEL01GYN001 |
|---|
| Value | Count | Frequency (%) | |
| BETBEL01GYN001 | 45408 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
| Distinct | 45408 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 354.8 KiB |
| Minimum | 2022-07-14 10:56:50 |
|---|---|
| Maximum | 2022-09-21 10:19:56 |
Histogram with fixed size bins (bins=50)
| Distinct | 77 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.24696089 |
|---|---|
| Minimum | 0 |
| Maximum | 80 |
| Zeros | 688 |
| Zeros (%) | 1.5% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 20 |
| median | 31 |
| Q3 | 43 |
| 95-th percentile | 61 |
| Maximum | 80 |
| Range | 80 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 15.46019435 |
|---|---|
| Coefficient of variation (CV) | 0.4794310509 |
| Kurtosis | 0.2494035011 |
| Mean | 32.24696089 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.5482659839 |
| Sum | 1464270 |
| Variance | 239.0176092 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 50 | 1122 | 2.5% | |
| 19 | 1062 | 2.3% | |
| 25 | 1045 | 2.3% | |
| 16 | 1037 | 2.3% | |
| 36 | 1030 | 2.3% | |
| 10 | 1029 | 2.3% | |
| 28 | 1029 | 2.3% | |
| 20 | 1028 | 2.3% | |
| 31 | 1028 | 2.3% | |
| 24 | 1025 | 2.3% | |
| Other values (67) | 34973 | 77.0% |
| Value | Count | Frequency (%) | |
| 0 | 688 | 1.5% | |
| 5 | 1 | < 0.1% | |
| 6 | 6 | < 0.1% | |
| 7 | 5 | < 0.1% | |
| 8 | 6 | < 0.1% |
| Value | Count | Frequency (%) | |
| 80 | 120 | 0.3% | |
| 79 | 122 | 0.3% | |
| 78 | 115 | 0.3% | |
| 77 | 121 | 0.3% | |
| 76 | 117 | 0.3% |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.785192037 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros | 7523 |
| Zeros (%) | 16.6% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.007335432 |
|---|---|
| Coefficient of variation (CV) | 0.7207170657 |
| Kurtosis | -0.5906881302 |
| Mean | 2.785192037 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.3201720392 |
| Sum | 126470 |
| Variance | 4.029395536 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) | |
| 5 | 7825 | 17.2% | |
| 0 | 7523 | 16.6% | |
| 4 | 6882 | 15.2% | |
| 1 | 6862 | 15.1% | |
| 3 | 6860 | 15.1% | |
| 2 | 6766 | 14.9% | |
| 8 | 912 | 2.0% | |
| 6 | 899 | 2.0% | |
| 7 | 879 | 1.9% |
| Value | Count | Frequency (%) | |
| 0 | 7523 | 16.6% | |
| 1 | 6862 | 15.1% | |
| 2 | 6766 | 14.9% | |
| 3 | 6860 | 15.1% | |
| 4 | 6882 | 15.2% |
| Value | Count | Frequency (%) | |
| 8 | 912 | 2.0% | |
| 7 | 879 | 1.9% | |
| 6 | 899 | 2.0% | |
| 5 | 7825 | 17.2% | |
| 4 | 6882 | 15.2% |
peak_upload_speed
Real number (ℝ≥0)
| Distinct | 13718 |
|---|---|
| Distinct (%) | 30.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46387.62971 |
|---|---|
| Minimum | 20054 |
| Maximum | 79991 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 20054 |
|---|---|
| 5-th percentile | 40419.35 |
| Q1 | 42614.75 |
| median | 45371.5 |
| Q3 | 48109 |
| 95-th percentile | 60985.2 |
| Maximum | 79991 |
| Range | 59937 |
| Interquartile range (IQR) | 5494.25 |
Descriptive statistics
| Standard deviation | 6752.364731 |
|---|---|
| Coefficient of variation (CV) | 0.1455639094 |
| Kurtosis | 8.327856389 |
| Mean | 46387.62971 |
| Median Absolute Deviation (MAD) | 2747.5 |
| Skewness | 2.320459002 |
| Sum | 2106369490 |
| Variance | 45594429.46 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 28251 | 40 | 0.1% | |
| 41977 | 16 | < 0.1% | |
| 46171 | 16 | < 0.1% | |
| 47684 | 14 | < 0.1% | |
| 40027 | 14 | < 0.1% | |
| 43226 | 13 | < 0.1% | |
| 41322 | 13 | < 0.1% | |
| 41931 | 13 | < 0.1% | |
| 46418 | 12 | < 0.1% | |
| 46995 | 12 | < 0.1% | |
| Other values (13708) | 45245 | 99.6% |
| Value | Count | Frequency (%) | |
| 20054 | 1 | < 0.1% | |
| 20114 | 1 | < 0.1% | |
| 20147 | 1 | < 0.1% | |
| 20181 | 1 | < 0.1% | |
| 20198 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 79991 | 1 | < 0.1% | |
| 79986 | 2 | < 0.1% | |
| 79981 | 1 | < 0.1% | |
| 79975 | 1 | < 0.1% | |
| 79973 | 1 | < 0.1% |
| Distinct | 12997 |
|---|---|
| Distinct (%) | 28.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15645.82063 |
|---|---|
| Minimum | 0 |
| Maximum | 31996 |
| Zeros | 688 |
| Zeros (%) | 1.5% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10371 |
| Q1 | 12609 |
| median | 15370 |
| Q3 | 18112 |
| 95-th percentile | 24370.65 |
| Maximum | 31996 |
| Range | 31996 |
| Interquartile range (IQR) | 5503 |
Descriptive statistics
| Standard deviation | 4597.249955 |
|---|---|
| Coefficient of variation (CV) | 0.2938324594 |
| Kurtosis | 2.825411458 |
| Mean | 15645.82063 |
| Median Absolute Deviation (MAD) | 2753 |
| Skewness | 0.4669793372 |
| Sum | 710445423 |
| Variance | 21134707.15 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 688 | 1.5% | |
| 16051 | 13 | < 0.1% | |
| 10031 | 13 | < 0.1% | |
| 13065 | 13 | < 0.1% | |
| 18217 | 13 | < 0.1% | |
| 19658 | 13 | < 0.1% | |
| 18333 | 12 | < 0.1% | |
| 18726 | 12 | < 0.1% | |
| 19963 | 12 | < 0.1% | |
| 11620 | 12 | < 0.1% | |
| Other values (12987) | 44607 | 98.2% |
| Value | Count | Frequency (%) | |
| 0 | 688 | 1.5% | |
| 5800 | 1 | < 0.1% | |
| 6193 | 1 | < 0.1% | |
| 6249 | 1 | < 0.1% | |
| 6444 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 31996 | 1 | < 0.1% | |
| 31993 | 2 | < 0.1% | |
| 31980 | 1 | < 0.1% | |
| 31979 | 1 | < 0.1% | |
| 31968 | 1 | < 0.1% |
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.573577343 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros | 4380 |
| Zeros (%) | 9.6% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.808784855 |
|---|---|
| Coefficient of variation (CV) | 0.683364493 |
| Kurtosis | -0.4357941262 |
| Mean | 5.573577343 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.3882055544 |
| Sum | 253085 |
| Variance | 14.50684207 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) | |
| 0 | 4380 | 9.6% | |
| 10 | 4342 | 9.6% | |
| 9 | 3801 | 8.4% | |
| 3 | 3797 | 8.4% | |
| 2 | 3788 | 8.3% | |
| 6 | 3781 | 8.3% | |
| 5 | 3755 | 8.3% | |
| 7 | 3742 | 8.2% | |
| 1 | 3683 | 8.1% | |
| 8 | 3636 | 8.0% | |
| Other values (7) | 6703 | 14.8% |
| Value | Count | Frequency (%) | |
| 0 | 4380 | 9.6% | |
| 1 | 3683 | 8.1% | |
| 2 | 3788 | 8.3% | |
| 3 | 3797 | 8.4% | |
| 4 | 3628 | 8.0% |
| Value | Count | Frequency (%) | |
| 16 | 493 | 1.1% | |
| 15 | 507 | 1.1% | |
| 14 | 550 | 1.2% | |
| 13 | 547 | 1.2% | |
| 12 | 489 | 1.1% |
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.557500881 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros | 4428 |
| Zeros (%) | 9.8% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.80768518 |
|---|---|
| Coefficient of variation (CV) | 0.6851434236 |
| Kurtosis | -0.4218168322 |
| Mean | 5.557500881 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.3909068823 |
| Sum | 252355 |
| Variance | 14.49846643 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) | |
| 0 | 4428 | 9.8% | |
| 10 | 4239 | 9.3% | |
| 8 | 3815 | 8.4% | |
| 6 | 3778 | 8.3% | |
| 3 | 3772 | 8.3% | |
| 9 | 3759 | 8.3% | |
| 1 | 3751 | 8.3% | |
| 2 | 3746 | 8.2% | |
| 7 | 3715 | 8.2% | |
| 5 | 3683 | 8.1% | |
| Other values (7) | 6722 | 14.8% |
| Value | Count | Frequency (%) | |
| 0 | 4428 | 9.8% | |
| 1 | 3751 | 8.3% | |
| 2 | 3746 | 8.2% | |
| 3 | 3772 | 8.3% | |
| 4 | 3660 | 8.1% |
| Value | Count | Frequency (%) | |
| 16 | 511 | 1.1% | |
| 15 | 525 | 1.2% | |
| 14 | 514 | 1.1% | |
| 13 | 477 | 1.1% | |
| 12 | 494 | 1.1% |
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.567168781 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros | 4425 |
| Zeros (%) | 9.7% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.804269072 |
|---|---|
| Coefficient of variation (CV) | 0.6833399923 |
| Kurtosis | -0.4138335223 |
| Mean | 5.567168781 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.3887477199 |
| Sum | 252794 |
| Variance | 14.47246317 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) | |
| 0 | 4425 | 9.7% | |
| 10 | 4143 | 9.1% | |
| 6 | 3833 | 8.4% | |
| 9 | 3822 | 8.4% | |
| 7 | 3816 | 8.4% | |
| 8 | 3768 | 8.3% | |
| 1 | 3748 | 8.3% | |
| 3 | 3741 | 8.2% | |
| 4 | 3725 | 8.2% | |
| 5 | 3661 | 8.1% | |
| Other values (7) | 6726 | 14.8% |
| Value | Count | Frequency (%) | |
| 0 | 4425 | 9.7% | |
| 1 | 3748 | 8.3% | |
| 2 | 3641 | 8.0% | |
| 3 | 3741 | 8.2% | |
| 4 | 3725 | 8.2% |
| Value | Count | Frequency (%) | |
| 16 | 511 | 1.1% | |
| 15 | 510 | 1.1% | |
| 14 | 535 | 1.2% | |
| 13 | 507 | 1.1% | |
| 12 | 505 | 1.1% |
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.559923362 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros | 4547 |
| Zeros (%) | 10.0% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.819797757 |
|---|---|
| Coefficient of variation (CV) | 0.6870234549 |
| Kurtosis | -0.4328376346 |
| Mean | 5.559923362 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.3899723522 |
| Sum | 252465 |
| Variance | 14.5908549 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) | |
| 0 | 4547 | 10.0% | |
| 10 | 4267 | 9.4% | |
| 5 | 3867 | 8.5% | |
| 9 | 3762 | 8.3% | |
| 8 | 3740 | 8.2% | |
| 2 | 3731 | 8.2% | |
| 4 | 3716 | 8.2% | |
| 6 | 3709 | 8.2% | |
| 1 | 3676 | 8.1% | |
| 7 | 3649 | 8.0% | |
| Other values (7) | 6744 | 14.9% |
| Value | Count | Frequency (%) | |
| 0 | 4547 | 10.0% | |
| 1 | 3676 | 8.1% | |
| 2 | 3731 | 8.2% | |
| 3 | 3635 | 8.0% | |
| 4 | 3716 | 8.2% |
| Value | Count | Frequency (%) | |
| 16 | 499 | 1.1% | |
| 15 | 524 | 1.2% | |
| 14 | 542 | 1.2% | |
| 13 | 517 | 1.1% | |
| 12 | 528 | 1.2% |
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.54005902 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros | 4499 |
| Zeros (%) | 9.9% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.815846878 |
|---|---|
| Coefficient of variation (CV) | 0.6887736871 |
| Kurtosis | -0.4115652841 |
| Mean | 5.54005902 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.4032462839 |
| Sum | 251563 |
| Variance | 14.5606874 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) | |
| 0 | 4499 | 9.9% | |
| 10 | 4231 | 9.3% | |
| 7 | 3789 | 8.3% | |
| 2 | 3764 | 8.3% | |
| 6 | 3762 | 8.3% | |
| 1 | 3760 | 8.3% | |
| 5 | 3752 | 8.3% | |
| 8 | 3719 | 8.2% | |
| 4 | 3719 | 8.2% | |
| 3 | 3702 | 8.2% | |
| Other values (7) | 6711 | 14.8% |
| Value | Count | Frequency (%) | |
| 0 | 4499 | 9.9% | |
| 1 | 3760 | 8.3% | |
| 2 | 3764 | 8.3% | |
| 3 | 3702 | 8.2% | |
| 4 | 3719 | 8.2% |
| Value | Count | Frequency (%) | |
| 16 | 515 | 1.1% | |
| 15 | 519 | 1.1% | |
| 14 | 535 | 1.2% | |
| 13 | 510 | 1.1% | |
| 12 | 489 | 1.1% |
| Distinct | 77 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.38960095 |
|---|---|
| Minimum | 0 |
| Maximum | 80 |
| Zeros | 688 |
| Zeros (%) | 1.5% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 20 |
| median | 32 |
| Q3 | 43 |
| 95-th percentile | 61 |
| Maximum | 80 |
| Range | 80 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 15.44282706 |
|---|---|
| Coefficient of variation (CV) | 0.4767834924 |
| Kurtosis | 0.2334887546 |
| Mean | 32.38960095 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.5299801037 |
| Sum | 1470747 |
| Variance | 238.4809076 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 50 | 1114 | 2.5% | |
| 42 | 1063 | 2.3% | |
| 40 | 1058 | 2.3% | |
| 45 | 1047 | 2.3% | |
| 26 | 1046 | 2.3% | |
| 10 | 1043 | 2.3% | |
| 22 | 1039 | 2.3% | |
| 44 | 1038 | 2.3% | |
| 35 | 1037 | 2.3% | |
| 49 | 1026 | 2.3% | |
| Other values (67) | 34897 | 76.9% |
| Value | Count | Frequency (%) | |
| 0 | 688 | 1.5% | |
| 5 | 1 | < 0.1% | |
| 6 | 3 | < 0.1% | |
| 7 | 6 | < 0.1% | |
| 8 | 6 | < 0.1% |
| Value | Count | Frequency (%) | |
| 80 | 109 | 0.2% | |
| 79 | 112 | 0.2% | |
| 78 | 124 | 0.3% | |
| 77 | 109 | 0.2% | |
| 76 | 116 | 0.3% |
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.548163319 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros | 4468 |
| Zeros (%) | 9.8% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.818170728 |
|---|---|
| Coefficient of variation (CV) | 0.6881864336 |
| Kurtosis | -0.4126377066 |
| Mean | 5.548163319 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.4039062889 |
| Sum | 251931 |
| Variance | 14.57842771 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) | |
| 0 | 4468 | 9.8% | |
| 10 | 4356 | 9.6% | |
| 6 | 3813 | 8.4% | |
| 5 | 3788 | 8.3% | |
| 4 | 3771 | 8.3% | |
| 1 | 3766 | 8.3% | |
| 3 | 3727 | 8.2% | |
| 2 | 3717 | 8.2% | |
| 9 | 3693 | 8.1% | |
| 8 | 3621 | 8.0% | |
| Other values (7) | 6688 | 14.7% |
| Value | Count | Frequency (%) | |
| 0 | 4468 | 9.8% | |
| 1 | 3766 | 8.3% | |
| 2 | 3717 | 8.2% | |
| 3 | 3727 | 8.2% | |
| 4 | 3771 | 8.3% |
| Value | Count | Frequency (%) | |
| 16 | 519 | 1.1% | |
| 15 | 550 | 1.2% | |
| 14 | 512 | 1.1% | |
| 13 | 467 | 1.0% | |
| 12 | 506 | 1.1% |
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.563028541 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros | 4421 |
| Zeros (%) | 9.7% |
| Memory size | 354.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.812689964 |
|---|---|
| Coefficient of variation (CV) | 0.685362287 |
| Kurtosis | -0.4321072525 |
| Mean | 5.563028541 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.3901191473 |
| Sum | 252606 |
| Variance | 14.53660476 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) | |
| 0 | 4421 | 9.7% | |
| 10 | 4281 | 9.4% | |
| 2 | 3839 | 8.5% | |
| 9 | 3763 | 8.3% | |
| 6 | 3762 | 8.3% | |
| 5 | 3759 | 8.3% | |
| 8 | 3742 | 8.2% | |
| 1 | 3721 | 8.2% | |
| 3 | 3695 | 8.1% | |
| 7 | 3681 | 8.1% | |
| Other values (7) | 6744 | 14.9% |
| Value | Count | Frequency (%) | |
| 0 | 4421 | 9.7% | |
| 1 | 3721 | 8.2% | |
| 2 | 3839 | 8.5% | |
| 3 | 3695 | 8.1% | |
| 4 | 3641 | 8.0% |
| Value | Count | Frequency (%) | |
| 16 | 516 | 1.1% | |
| 15 | 506 | 1.1% | |
| 14 | 514 | 1.1% | |
| 13 | 515 | 1.1% | |
| 12 | 502 | 1.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| client_id | stats_timestamp | total_attached_user | total_rejected_user | peak_upload_speed | peak_download_speed | enodeb_shutdown_count | handover_failure_count | bearer_active_user_count | bearer_rejected_user_count | total_users | total_dropped_packets | enodeb_connected_count | enodeb_connection_status | total_tx_data | total_rx_data | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | BETBEL01GYN001 | 2022-07-14 10:56:50 | 0 | 0 | 28251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | None | None |
| 1 | BETBEL01GYN001 | 2022-07-14 11:05:55 | 0 | 0 | 28251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | None | None |
| 2 | BETBEL01GYN001 | 2022-07-14 11:07:04 | 0 | 0 | 28251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | None | None |
| 3 | BETBEL01GYN001 | 2022-07-14 11:08:03 | 0 | 0 | 28251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | None | None |
| 4 | BETBEL01GYN001 | 2022-07-14 11:08:05 | 0 | 0 | 28251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | None | None |
| 5 | BETBEL01GYN001 | 2022-07-14 11:08:07 | 0 | 0 | 28251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | None | None |
| 6 | BETBEL01GYN001 | 2022-07-14 11:08:09 | 0 | 0 | 28251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | None | None |
| 7 | BETBEL01GYN001 | 2022-07-14 11:08:11 | 0 | 0 | 28251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | None | None |
| 8 | BETBEL01GYN001 | 2022-07-14 11:08:13 | 0 | 0 | 28251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | None | None |
| 9 | BETBEL01GYN001 | 2022-07-14 11:08:15 | 0 | 0 | 28251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | None | None |
Last rows
| client_id | stats_timestamp | total_attached_user | total_rejected_user | peak_upload_speed | peak_download_speed | enodeb_shutdown_count | handover_failure_count | bearer_active_user_count | bearer_rejected_user_count | total_users | total_dropped_packets | enodeb_connected_count | enodeb_connection_status | total_tx_data | total_rx_data | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45398 | BETBEL01GYN001 | 2022-09-21 10:01:55 | 27 | 1 | 46762 | 15396 | 10 | 1 | 1 | 1 | 8 | 43 | 10 | 10.0 | None | None |
| 45399 | BETBEL01GYN001 | 2022-09-21 10:03:56 | 14 | 0 | 49018 | 16710 | 6 | 4 | 0 | 9 | 5 | 31 | 0 | 6.0 | None | None |
| 45400 | BETBEL01GYN001 | 2022-09-21 10:05:56 | 10 | 0 | 49344 | 13201 | 2 | 3 | 0 | 9 | 7 | 29 | 1 | 2.0 | None | None |
| 45401 | BETBEL01GYN001 | 2022-09-21 10:07:56 | 37 | 4 | 41425 | 18885 | 2 | 6 | 8 | 6 | 0 | 45 | 2 | 9.0 | None | None |
| 45402 | BETBEL01GYN001 | 2022-09-21 10:09:56 | 27 | 2 | 46359 | 13725 | 10 | 10 | 8 | 10 | 9 | 36 | 6 | 8.0 | None | None |
| 45403 | BETBEL01GYN001 | 2022-09-21 10:11:56 | 49 | 1 | 44147 | 11199 | 3 | 3 | 10 | 4 | 9 | 30 | 5 | 7.0 | None | None |
| 45404 | BETBEL01GYN001 | 2022-09-21 10:13:56 | 13 | 2 | 47262 | 18825 | 10 | 8 | 7 | 6 | 1 | 22 | 7 | 9.0 | None | None |
| 45405 | BETBEL01GYN001 | 2022-09-21 10:15:56 | 49 | 3 | 47876 | 11605 | 2 | 3 | 9 | 4 | 0 | 13 | 5 | 1.0 | None | None |
| 45406 | BETBEL01GYN001 | 2022-09-21 10:17:56 | 27 | 2 | 42779 | 16834 | 8 | 7 | 6 | 2 | 2 | 16 | 2 | 5.0 | None | None |
| 45407 | BETBEL01GYN001 | 2022-09-21 10:19:56 | 38 | 2 | 44990 | 11970 | 7 | 8 | 5 | 8 | 5 | 39 | 5 | 6.0 | None | None |